Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Prepare to produce spreadsheets
   • Adjust workspace, furniture and equipment to suit own ergonomic, work organisation and work health and safety (WHS) requirements
   • Identify task purpose, audience and presentation requirements, and clarify with relevant personnel as required
   • Identify specific task requirements, including layout and delivery timeline, and clarify with relevant personnel as required
   • Select most appropriate application to produce spreadsheet, in accordance with available resources and organisational policies
2. Create simple spreadsheets
   • Ensure data is entered, checked and amended in accordance with organisational and task requirements, to maintain consistency of design and layout
   • Format spreadsheet using application functions; to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
   • Ensure formulae are used and tested to confirm output meets task requirements, in consultation with appropriate personnel as required
   • Use relevant help functions to overcome simple issues relating to spreadsheet design and production
3. Produce simple charts
   • Select chart type and design that enables valid representation of numerical data and meets organisational and task requirements
   • Create chart using appropriate data range in spreadsheet
   • Modify chart type and layout using formatting features
4. Finalise and present spreadsheets
   • Review and edit final spreadsheet and prepare for delivery in accordance with organisational and task requirements
   • Deliver document to relevant audience within designated timelines and in accordance with organisational requirements
   • Name and store spreadsheet appropriately in accordance with organisational requirements and exit application without data loss